--Execute as SYS
CREATE DIRECTORY resume_files AS '/home/oracle/labs/DATA_FILES/RESUMES';
Grant read on DIRECTORY resume_files to OE;

connect oe/oe;

set serveroutput on
set verify on
set term on
set linesize 200

timing start load_data 
execute write_lob('karl.brimmer.doc', 'RESUME_FILES')
execute write_lob('monica.petera.doc', 'RESUME_FILES')
execute write_lob('david.sloan.doc',  'RESUME_FILES')
timing stop
